CREATE VIEW [dbo].[vPledge]
AS
  SELECT    ID                         ID,
            max(TransactionNumber)     TransactionNumber,
            InvoiceReferenceNumber,
            max(TransactionDate)       TransactionDate,
            max(DateReceived)          DateReceived,
            max(FiscalYear)            FiscalYear,
            max(FiscalMonth)           FiscalMonth,
            Appeal,
            Campaign,
            Fund,
            max(SolicitorID)           SolicitorID,
            max(SourceSystem)          SourceSystem,
            max(MatchingTransaction)   MatchingTransaction,
            max(IsMatchingGift)        IsMatchingGift,
            max(MemorialID)            MemorialID,
            max(ListAs)                ListAs,
            max(RequestNumber)         RequestNumber,
            max(InstallmentDate)       InstallmentDate,
            max(LastPaymentDate)       LastPaymentDate,
            sum(PledgeAmount)          PledgeAmount,
            sum(AdjustmentsAmount)     AdjustmentsAmount,
            (sum(vPledgeData.PledgeAmount)  +  sum(vPledgeData.AdjustmentsAmount)) NetPledgeAmount,
            sum(PaymentsAmount)        PaymentsAmount,
            (sum(vPledgeData.PledgeAmount) + sum(vPledgeData.AdjustmentsAmount) - sum(vPledgeData.PaymentsAmount)) PledgeBalance,
            max(vPledgeData.PledgeFairMarketValue)    PledgeFairMarketValue,
            max(MemorialNameText)      MemorialNameText     
     FROM vPledgeData
  GROUP BY ID, InvoiceReferenceNumber, Fund, Campaign, Appeal

GO
GRANT REFERENCES ON  [dbo].[vPledge] TO [IMIS]
GRANT SELECT ON  [dbo].[vPledge] TO [IMIS]
GRANT INSERT ON  [dbo].[vPledge] TO [IMIS]
GRANT DELETE ON  [dbo].[vPledge] TO [IMIS]
GRANT UPDATE ON  [dbo].[vPledge] TO [IMIS]
GO